#ifndef SQLITEDBWRAPPER_H
#define SQLITEDBWRAPPER_H
#include "sqlite3.h"
#include "lp_types.h"
#include <iostream>



class SqliteDbWrapper
{
    //Accepts a SQL query string and uses this to populate an STL vector using the
    //StopData type
    //---
    // NOTE: This class is not particularly flexible at the moment, as it only
    //yields a result set in a very specific format.
public:
     SqliteDbWrapper(sqlite3* dbConnection);

    std::vector<StopData> StopVector;
    int QueryStops(const char* sqlString);
    std::string GetStyleSheet(const char* routeID);

private:
    sqlite3* m_db;
    sqlite3_stmt* m_statement;

    StopItr m_it;
};


#endif // SQLITEDBWRAPPER_H
